﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>Performing Transactions with the JDBC Driver</title>
    
    <link rel="stylesheet" type="text/css" href="../local/Classic.css">
      
    </link>
    
    <script src="../local/script.js">
      
    </script><script src="../local/script_main.js">&amp;nbsp;</script>
  </head>
  <body>
    <!--Topic built:09/24/2007 09:01:38-->

    
    
    
    
    
    
    
    
    
    <div id="header">
      <table width="100%" id="topTable"><tr>
          <td align="left">
            <span id="headerBold">Performing Transactions with the JDBC Driver</span>
          </td>
          <td align="right">
            
          </td>
        </tr></table>
      
      
      
    </div>
    <div id="mainSection">
      
        
        
		<font color="DarkGray"><!-- [This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]<br/>[Documentation built on $$TIMESTAMP$$]  --> </font> <p /> <p />
	
        <div id="introductionSection" class="section">
    <p>Transaction processing is a mandatory requirement of all applications that must guarantee consistency of their persistent data. With the Microsoft SQL Server 2005 JDBC Driver, transaction processing can either be performed locally or distributed. Transactions are atomic, consistent, isolated, and durable (ACID) modules of execution. </p>
    <p>The topics in this section describe how the JDBC driver supports transactions including isolation levels, transaction savepoints, and result set holdability.</p>
  </div><h1 class="heading">In This Section</h1><div id="inThisSectionSection" class="section">
    <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Topic
            </th>
            <th>
              Description
            </th>
          </tr><tr>
          <td>
            <p>
              <a href="d3e0414c-6809-4bb1-93b1-4960507faecc.htm">Understanding Transactions</a>
            </p>
          </td>
          <td>
            <p>Provides an overview of how transactions are used with the JDBC driver.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="574e326f-0520-4003-bdf1-62d92c3db457.htm">Understanding XA Transactions</a>
            </p>
          </td>
          <td>
            <p>Provides an overview of how XA transactions are used with the JDBC driver.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="2c41e23a-da6c-4650-b5fc-b5fe53ba65c3.htm">Understanding Isolation Levels</a>
            </p>
          </td>
          <td>
            <p>Describes the various isolation levels that are supported by the JDBC driver.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="3b48eb13-32ef-4fb3-8e95-dbc9468c9a44.htm">Using Savepoints</a>
            </p>
          </td>
          <td>
            <p>Describes how to use the JDBC driver with transaction savepoints.</p>
          </td>
        </tr><tr>
          <td>
            <p>
              <a href="aa48306c-e7a0-4dcb-af21-9ebb6898e45a.htm">Using Holdability</a>
            </p>
          </td>
          <td>
            <p>Describes how to use the JDBC driver with result set holdability.</p>
          </td>
        </tr></table>
    </content>
  </div><span id="seeAlsoSpan"><h1 class="heading">See Also</h1></span><div id="seeAlsoSection" class="section" name="collapseableSection"><a href="939a8773-2583-49a4-bf00-6b892fbe39dc.htm">Overview of the JDBC Driver</a><br /><br /></div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]-->
      <div id="footer" class="section">
        
		<hr />
		
		<span id="fb" class="feedbackcss">
			
			
		</span>
		
		<a href="9bad553b-9e70-4696-8499-2e35f772a1e0.htm">
			
			© 2007 Microsoft Corporation. All rights reserved.
		</a>
 	
	
      </div>
    </div>
  </body>
</html>